{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Task_Table","Resource_Table","Assignment_Table","Info_Table"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Task_Table","index":0,"n_rows":84,"n_cols":6,"rows_kept":84,"flags":["formulas_cached_only"]}
["ID","Name","Duration","Start","Finish","Resources"]
[1,"Project Office template",{"v":155,"d":"155.d"},"2000-01-03T08:00:00","2000-08-04T17:00:00"]
[2,"Scope",{"v":10,"d":"10.d"},"2000-01-03T08:00:00","2000-01-14T17:00:00","District Senior Staff, PMO Exec"]
[3,"Determine project office scope",{"v":3,"d":"3.d"},"2000-01-03T08:00:00","2000-01-05T17:00:00"]
[4,"Document high-level Project Office requirements including resources",{"v":2,"d":"2.d"},"2000-01-06T08:00:00","2000-01-07T17:00:00"]
[5,"Justify Project Office via business model",{"v":3,"d":"3.d"},"2000-01-10T08:00:00","2000-01-12T17:00:00"]
[6,"Secure executive sponsorship",{"v":2,"d":"2.d"},"2000-01-13T08:00:00","2000-01-14T17:00:00"]
[7,"Scope complete",0,"2000-01-14T17:00:00","2000-01-14T17:00:00"]
[8,"Planning",{"v":66.5,"d":"66.5d"},"2000-01-17T08:00:00","2000-04-18T12:00:00","District Senior Staff, PMO Exec"]
[9,"Analysis/Logistics",{"v":17,"d":"17.d"},"2000-01-17T08:00:00","2000-02-08T17:00:00"]
[10,"Review Project Office scope documentation",{"v":1,"d":"1.d"},"2000-01-17T08:00:00","2000-01-17T17:00:00"]
[11,"Establish a management Framework",{"v":3,"d":"3.d"},"2000-01-18T08:00:00","2000-01-20T17:00:00"]
[12,"Analyze business objectives",{"v":2,"d":"2.d"},"2000-01-21T08:00:00","2000-01-24T17:00:00"]
[13,"Define mission statement",{"v":2,"d":"2.d"},"2000-01-25T08:00:00","2000-01-26T17:00:00"]
[14,"Define goals",{"v":3,"d":"3.d"},"2000-01-27T08:00:00","2000-01-31T17:00:00"]
[15,"Establish communications plan",{"v":1,"d":"1.d"},"2000-02-01T08:00:00","2000-02-01T17:00:00"]
[16,"Secure Project Office core resources",{"v":5,"d":"5.d"},"2000-02-02T08:00:00","2000-02-08T17:00:00"]
[17,"Logistics complete",0,"2000-02-08T17:00:00","2000-02-08T17:00:00"]
[18,"Policies and Procedures",{"v":20,"d":"20.d"},"2000-02-09T08:00:00","2000-03-07T17:00:00"]
[19,"Define \"best of breed\" processes",{"v":5,"d":"5.d"},"2000-02-09T08:00:00","2000-02-15T17:00:00"]
[20,"Define \"best of breed\" tools",{"v":5,"d":"5.d"},"2000-02-09T08:00:00","2000-02-15T17:00:00"]
[21,"Define \"best of breed\" techniques",{"v":5,"d":"5.d"},"2000-02-09T08:00:00","2000-02-15T17:00:00"]
[22,"Establish resource relationships",{"v":5,"d":"5.d"},"2000-02-09T08:00:00","2000-02-15T17:00:00"]
[23,"Define compliance criteria",{"v":5,"d":"5.d"},"2000-02-09T08:00:00","2000-02-15T17:00:00"]
[24,"Define project test processes",{"v":5,"d":"5.d"},"2000-02-16T08:00:00","2000-02-22T17:00:00"]
[25,"Define reporting requirements",{"v":5,"d":"5.d"},"2000-02-23T08:00:00","2000-02-29T17:00:00"]
[26,"Define Project Office priorities",{"v":5,"d":"5.d"},"2000-03-01T08:00:00","2000-03-07T17:00:00"]
[27,"Policies and procedures complete",0,"2000-03-07T17:00:00","2000-03-07T17:00:00"]
[28,"Project Standards and Controls",{"v":28,"d":"28.d"},"2000-03-08T08:00:00","2000-04-14T17:00:00"]
[29,"Define security/roles/responsibilities",{"v":3,"d":"3.d"},"2000-03-08T08:00:00","2000-03-10T17:00:00"]
[30,"Define system parameters",{"v":5,"d":"5.d"},"2000-03-13T08:00:00","2000-03-17T17:00:00"]
[31,"Create project numbering schema",{"v":2,"d":"2.d"},"2000-03-20T08:00:00","2000-03-21T17:00:00"]
[32,"Define financial reporting integration",{"v":5,"d":"5.d"},"2000-03-22T08:00:00","2000-03-28T17:00:00"]
[33,"Identify project categories for template creation",{"v":3,"d":"3.d"},"2000-03-29T08:00:00","2000-03-31T17:00:00"]
[34,"Create project templates",{"v":10,"d":"10.d"},"2000-04-03T08:00:00","2000-04-14T17:00:00"]
[35,"Project standards and controls complete",0,"2000-04-14T17:00:00","2000-04-14T17:00:00"]
[36,"Empower Project Office",{"v":1,"d":"1.d"},"2000-04-17T08:00:00","2000-04-17T17:00:00"]
[37,"Announce Project Office",{"v":0.5,"d":".5d"},"2000-04-18T08:00:00","2000-04-18T12:00:00"]
[38,"Planning complete",0,"2000-04-18T12:00:00","2000-04-18T12:00:00"]
[39,"Initiate Project Office",{"v":27,"d":"27.d"},"2000-04-18T13:00:00","2000-05-25T12:00:00","District Senior Staff, PMO Exec, Proj. Mgrs, Bus Analysts"]
[40,"Staff Project Office personnel",{"v":5,"d":"5.d"},"2000-04-18T13:00:00","2000-04-25T12:00:00"]
[41,"Project Office Support for Existing Projects",{"v":11,"d":"11.d"},"2000-04-25T13:00:00","2000-05-10T12:00:00"]
[42,"Determine existing projects for Project Office",{"v":2,"d":"2.d"},"2000-04-25T13:00:00","2000-04-27T12:00:00"]
[43,"Audit projects",{"v":5,"d":"5.d"},"2000-04-27T13:00:00","2000-05-04T12:00:00","Proj Mgrs."]
[44,"Modify projects for compliance",{"v":3,"d":"3.d"},"2000-05-04T13:00:00","2000-05-09T12:00:00","Proj Mgrs."]
[45,"Enter projects into Project Office management",{"v":1,"d":"1.d"},"2000-05-09T13:00:00","2000-05-10T12:00:00","Proj Mgrs."]
[46,"Project Office support for existing projects complete",0,"2000-05-10T12:00:00","2000-05-10T12:00:00"]
[47,"Project Office support for new projects",{"v":27,"d":"27.d"},"2000-04-18T13:00:00","2000-05-25T12:00:00"]
[48,"Identify new projects for Project Office",{"v":5,"d":"5.d"},"2000-04-18T13:00:00","2000-04-25T12:00:00"]
[49,"Create project using Project Office criteria/templates",{"v":10,"d":"10.d"},"2000-04-25T13:00:00","2000-05-09T12:00:00","Proj Mgrs."]
[50,"Establish monitoring criteria",{"v":3,"d":"3.d"},"2000-05-09T13:00:00","2000-05-12T12:00:00","Proj Mgrs."]
[51,"Establish performance metrics",{"v":4,"d":"4.d"},"2000-05-12T13:00:00","2000-05-18T12:00:00","Proj Mgrs."]
[52,"Establish budget guidelines",{"v":3,"d":"3.d"},"2000-05-18T13:00:00","2000-05-23T12:00:00","Proj Mgrs."]
[53,"Enter project into Project Office management",{"v":2,"d":"2.d"},"2000-05-23T13:00:00","2000-05-25T12:00:00","Proj Mgrs."]
[54,"Project Office support for new projects complete",0,"2000-05-25T12:00:00","2000-05-25T12:00:00","Proj Mgrs."]
[55,"Initiate Project Office complete",0,"2000-05-25T12:00:00","2000-05-25T12:00:00"]
[56,"Management (ongoing)",{"v":25.5,"d":"25.5d"},"2000-05-25T13:00:00","2000-06-29T17:00:00","PMO Exec, Proj Mgrs"]
[57,"Review business priorities applicable to projects",{"v":5,"d":"5.d"},"2000-05-25T13:00:00","2000-06-01T12:00:00"]
[58,"Risk Assessment",{"v":9,"d":"9.d"},"2000-06-01T13:00:00","2000-06-14T12:00:00"]
[59,"Perform risk assessment",{"v":5,"d":"5.d"},"2000-06-01T13:00:00","2000-06-08T12:00:00"]
[60,"Evaluate risk assessment against project priorities",{"v":3,"d":"3.d"},"2000-06-08T13:00:00","2000-06-13T12:00:00"]
[61,"Prepare contingency plans",{"v":1,"d":"1.d"},"2000-06-13T13:00:00","2000-06-14T12:00:00"]
[62,"Risk assessment complete",0,"2000-06-14T12:00:00","2000-06-14T12:00:00"]
[63,"Monitoring",{"v":11.5,"d":"11.5d"},"2000-06-14T13:00:00","2000-06-29T17:00:00","PMO Exec, Proj Mgrs"]
[64,"Prepare project review meeting agenda",{"v":1,"d":"1.d"},"2000-06-14T13:00:00","2000-06-15T12:00:00","Proj Mgrs."]
[65,"Conduct project review meetings",{"v":0.5,"d":".5d"},"2000-06-15T13:00:00","2000-06-15T17:00:00","Proj Mgrs."]
[66,"Create reports for critical issues, budgets, allocating resources, tracking progress, etc.",{"v":2,"d":"2.d"},"2000-06-16T08:00:00","2000-06-19T17:00:00","Proj Mgrs."]
[67,"Work to mitigate critical Issues",{"v":2,"d":"2.d"},"2000-06-20T08:00:00","2000-06-21T17:00:00","Proj Mgrs."]
[68,"Assist with allocating resources",{"v":2,"d":"2.d"},"2000-06-22T08:00:00","2000-06-23T17:00:00","Proj Mgrs."]
[69,"Freeze/release project baselines",{"v":2,"d":"2.d"},"2000-06-26T08:00:00","2000-06-27T17:00:00","Proj Mgrs."]
[70,"Establish change management control",{"v":1,"d":"1.d"},"2000-06-28T08:00:00","2000-06-28T17:00:00","Proj Mgrs."]
[71,"Freeze/release project budgets",{"v":1,"d":"1.d"},"2000-06-29T08:00:00","2000-06-29T17:00:00","Proj Mgrs."]
[72,"Monitoring complete",0,"2000-06-29T17:00:00","2000-06-29T17:00:00","Proj Mgrs."]
[73,"Historical/Archival",{"v":13,"d":"13.d"},"2000-06-30T08:00:00","2000-07-18T17:00:00","Proj Mgrs."]
[74,"Establish project archives",{"v":5,"d":"5.d"},"2000-06-30T08:00:00","2000-07-06T17:00:00"]
[75,"Establish lessons learned repository",{"v":5,"d":"5.d"},"2000-07-07T08:00:00","2000-07-13T17:00:00"]
[76,"Manage project archives",{"v":3,"d":"3.d"},"2000-07-14T08:00:00","2000-07-18T17:00:00"]
[77,"Historical complete",0,"2000-07-18T17:00:00","2000-07-18T17:00:00","PMO Exec, Proj Mgrs"]
[78,"Post Implementation Review",{"v":13,"d":"13.d"},"2000-07-19T08:00:00","2000-08-04T17:00:00"]
[79,"Obtain user feedback",{"v":3,"d":"3.d"},"2000-07-19T08:00:00","2000-07-21T17:00:00"]
[80,"Evaluate lessons learned",{"v":5,"d":"5.d"},"2000-07-24T08:00:00","2000-07-28T17:00:00"]
[81,"Modify Items as necessary",{"v":5,"d":"5.d"},"2000-07-31T08:00:00","2000-08-04T17:00:00"]
[82,"Post implementation review complete",0,"2000-08-04T17:00:00","2000-08-04T17:00:00"]
[83,"Project Office template complete",0,"2000-08-04T17:00:00","2000-08-04T17:00:00"]

{"sheet":"Resource_Table","index":1,"n_rows":6,"n_cols":12,"rows_kept":6,"flags":["formulas_cached_only"]}
["ID","Name","Initials","Type","Material Label","Group","Email Address","Windows User Account","Max Units","Standard Rate","Cost Per Use","Notes"]
[1,"Corporate management","C","Work",{"$nulls":4},"100%","$0.00/hr",{"v":0,"d":"$0.00"}]
[2,"Project Office coordinator","P","Work",{"$nulls":4},"100%","$0.00/hr",{"v":0,"d":"$0.00"}]
[3,"Analyst","A","Work",{"$nulls":4},"100%","$0.00/hr",{"v":0,"d":"$0.00"}]
[4,"Developer","D","Work",{"$nulls":4},"100%","$0.00/hr",{"v":0,"d":"$0.00"}]
[5,"Project Office staff analyst","P","Work",{"$nulls":4},"100%","$0.00/hr",{"v":0,"d":"$0.00"}]

{"sheet":"Assignment_Table","index":2,"n_rows":83,"n_cols":5,"rows_kept":83,"flags":["formulas_cached_only"]}
["Task Name","Resource Name","% Work Complete","Work","Units"]
["Determine project office scope","Corporate management",{"v":0,"d":"0%"},"24 hrs","100%"]
["Determine project office scope","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Document high-level Project Office requirements including resources","Corporate management",{"v":0,"d":"0%"},"16 hrs","100%"]
["Document high-level Project Office requirements including resources","Project Office coordinator",{"v":0,"d":"0%"},"16 hrs","100%"]
["Justify Project Office via business model","Corporate management",{"v":0,"d":"0%"},"24 hrs","100%"]
["Justify Project Office via business model","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Secure executive sponsorship","Corporate management",{"v":0,"d":"0%"},"16 hrs","100%"]
["Secure executive sponsorship","Project Office coordinator",{"v":0,"d":"0%"},"16 hrs","100%"]
["Review Project Office scope documentation","Project Office coordinator",{"v":0,"d":"0%"},"8 hrs","100%"]
["Establish a management Framework","Corporate management",{"v":0,"d":"0%"},"24 hrs","100%"]
["Establish a management Framework","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Analyze business objectives","Project Office coordinator",{"v":0,"d":"0%"},"16 hrs","100%"]
["Define mission statement","Project Office coordinator",{"v":0,"d":"0%"},"16 hrs","100%"]
["Define goals","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Establish communications plan","Project Office coordinator",{"v":0,"d":"0%"},"8 hrs","100%"]
["Secure Project Office core resources","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define \"best of breed\" processes","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define \"best of breed\" processes","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define \"best of breed\" tools","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define \"best of breed\" tools","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define \"best of breed\" techniques","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define \"best of breed\" techniques","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Establish resource relationships","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Establish resource relationships","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define compliance criteria","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define compliance criteria","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define project test processes","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define project test processes","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define reporting requirements","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define reporting requirements","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define Project Office priorities","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define Project Office priorities","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define security/roles/responsibilities","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Define security/roles/responsibilities","Analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Define system parameters","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define system parameters","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Create project numbering schema","Project Office coordinator",{"v":0,"d":"0%"},"16 hrs","100%"]
["Create project numbering schema","Analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Define financial reporting integration","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Define financial reporting integration","Analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Identify project categories for template creation","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Identify project categories for template creation","Analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Create project templates","Developer",{"v":0,"d":"0%"},"80 hrs","100%"]
["Empower Project Office","Corporate management",{"v":0,"d":"0%"},"8 hrs","100%"]
["Empower Project Office","Project Office coordinator",{"v":0,"d":"0%"},"8 hrs","100%"]
["Announce Project Office","Corporate management",{"v":0,"d":"0%"},"4 hrs","100%"]
["Announce Project Office","Project Office coordinator",{"v":0,"d":"0%"},"4 hrs","100%"]
["Staff Project Office personnel","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Determine existing projects for Project Office","Project Office coordinator",{"v":0,"d":"0%"},"16 hrs","100%"]
["Determine existing projects for Project Office","Project Office staff analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Audit projects","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Modify projects for compliance","Project Office staff analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Enter projects into Project Office management","Project Office staff analyst",{"v":0,"d":"0%"},"8 hrs","100%"]
["Identify new projects for Project Office","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Identify new projects for Project Office","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Create project using Project Office criteria/templates","Project Office staff analyst",{"v":0,"d":"0%"},"80 hrs","100%"]
["Establish monitoring criteria","Project Office staff analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Establish performance metrics","Project Office staff analyst",{"v":0,"d":"0%"},"32 hrs","100%"]
["Establish budget guidelines","Project Office staff analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Enter project into Project Office management","Project Office staff analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Review business priorities applicable to projects","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Perform risk assessment","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Evaluate risk assessment against project priorities","Project Office staff analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Prepare contingency plans","Project Office staff analyst",{"v":0,"d":"0%"},"8 hrs","100%"]
["Prepare project review meeting agenda","Project Office staff analyst",{"v":0,"d":"0%"},"8 hrs","100%"]
["Conduct project review meetings","Project Office staff analyst",{"v":0,"d":"0%"},"4 hrs","100%"]
["Create reports for critical issues, budgets, allocating resources, tracking progress, etc.","Project Office staff analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Work to mitigate critical Issues","Project Office staff analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Assist with allocating resources","Project Office staff analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Freeze/release project baselines","Project Office staff analyst",{"v":0,"d":"0%"},"16 hrs","100%"]
["Establish change management control","Project Office staff analyst",{"v":0,"d":"0%"},"8 hrs","100%"]
["Freeze/release project budgets","Project Office staff analyst",{"v":0,"d":"0%"},"8 hrs","100%"]
["Establish project archives","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Establish project archives","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Establish lessons learned repository","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Manage project archives","Project Office staff analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Obtain user feedback","Project Office coordinator",{"v":0,"d":"0%"},"24 hrs","100%"]
["Obtain user feedback","Project Office staff analyst",{"v":0,"d":"0%"},"24 hrs","100%"]
["Evaluate lessons learned","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Evaluate lessons learned","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]
["Modify Items as necessary","Project Office coordinator",{"v":0,"d":"0%"},"40 hrs","100%"]
["Modify Items as necessary","Project Office staff analyst",{"v":0,"d":"0%"},"40 hrs","100%"]

{"sheet":"Info_Table","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"flags":["formulas_cached_only"]}
["Microsoft Office Project",null,"Template ID:","9876543210","(Do Not Edit)"]
[]
["Microsoft Office Project is a project management program designed to help you plan and manage your projects and communicate project information."]
[]
["Whether you have a simple list of tasks or want to coordinate activities across multiple projects, Project makes it easy to get started and learn as you go."]
[]
["With this template you can export data to Excel to perform more advanced numerical analysis. Then you can import project data back into Project to perform standard project tasks, such as:"]
["* Seeing your tasks linked in a Gantt Chart"]
["* Seeing how much work each person on the team has assigned to them"]
["You can easily import this information back into Project and keep working without reentering data."]